Schema:
geographic (CITY_NAME, COUNTY, REGION)
restaurant (ID, NAME, FOOD_TYPE, CITY_NAME, RATING)
location (RESTAURANT_ID, HOUSE_NUMBER, STREET_NAME, CITY_NAME)
Please answer with SQL.